Get Excel Sheet Names
(Operator Toolbox)
Synopsis
This operator takes an Excel file and returns the list of sheets which are in this file.Description
A file can either be provided as a path or as a file object on the input port. The result is an ExampleSet with two attributes: Sheet Number and Sheet Name.Input
fil (File)The excel file which should be used. This is not mandatory. File objects can be generated with operators like Open File or Loop Files.
Output
exa (Data Table)The ExampleSet with the sheet names and numbers.
Parameters
- file_nameThe path to the Excel file. Range: configurable
Tutorial Processes
Read Sheet Names
In this example we generate an excel file and extract the sheet names of this generated file again using the file input port.
